{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Input","Screening","Database","MCA","MCA_1","MCA_4","MCA_5","Sum report"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Input","index":0,"n_rows":37,"n_cols":2,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
["WWTP name/city:","Koprivnica"]
[]
["WWTP location:","Croatia"]
[]
["Wastewater source activity:"]
[]
["Domestic",1]
["Industrial",1]
["Agriculture",1]
["Hospital",1]
[]
["WWTP capacity (m3/day):","8.700"]
[]
["Wastewater discharge:","Lotic water body"]
[]
["Receiving water body flow (m3/s):","163"]
[]
["WWTP technology:","Tertiary treatment"]
[]
["Sand filtration",1]
["Ultrafiltration membranes",1]
["Ultraviolet lamps",1]
["Reverse osmosis membranes",1]
["GAC filtration",1]
["AOP (Ozone)",1]
[]
["Advanced treatment fraction (%)","100"]
[]
["Sewage sludge management:","Properly treated and disposed"]
[]
["Agriculture reuse",0]
["Landfilling",1]
["Incineration",0]
[]
["Interest rate (%)","2,0"]
[]
["Lifespan of the project (years)",20]

{"sheet":"Screening","index":1,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[null,"Yes(1) / No(0)"]
["1. Known issues of micropollutants in the wastewater treatment plant",0]
["2. Existance of secondary treatment as a minimum level of treatment*",1]
["3. Power supply availability",1]
["4. Different source of wastewater contrubution other than domestic",1]
["5. Need for reuse",0]
["6. Wastewater discharge into a water body",0]
["7. The effluent discharges upstream a drinking water treatment plant",0]
["8. Sewage sludge management*",1]
["9. Sewage sludge final disposition method",0]
["10. Existance of a local regulation or policy regarding micropollutants",0]
[]
["Mandatory sum",{"$f":"SUM(B3,B9)","v":2}]
["Total sum",{"$f":"SUM(B2:B11)","v":4}]
[]
[]
[]
[]
[]
[null,""]
[null,""]
[null,""]
[null,""]
[]
[]
[]
[null,null,""]
[null,null,""]
[null,null,""]
[null,null,""]

{"sheet":"Database","index":2,"n_rows":57,"n_cols":6,"rows_kept":57,"cut":false,"hidden":false,"merged":[]}
[null,"Country","Drinking Water price (€/m3)","Water Exploitation Index (%)","WPMEI (%)","Energy (€/KWh)"]
[1,"Austria",3.67,"N/D",52,7.0400000000000004E-2]
[2,"Belgium",4.53,25.5,48,7.5300000000000006E-2]
[3,"Bulgaria",{"$f":"1.05/1.12","v":0.9375},5.6,51,0.08]
[4,"Croatia",1.98,0.6,48,8.48E-2]
[5,"Cyprus",2.9,72.3,58,0.1241]
[6,"Czech Republic",3.27,10,44,7.22E-2]
[7,"Denmark",9,4.5999999999999996,57,5.9299999999999999E-2]
[8,"Estonia",3.16,14,47,7.3099999999999998E-2]
[9,"Finland",5.89,6,67,6.1100000000000002E-2]
[10,"France",3.92,15.7,52,7.3700000000000002E-2]
[11,"Germany",{"$f":"6.06/1.12","v":5.4107142857142847},17.600000000000001,54,7.7100000000000002E-2]
[12,"Greece",1.4,13.8,64,7.9100000000000004E-2]
[13,"Hungary",2.65,4.3,49,7.3800000000000004E-2]
[14,"Ireland",{"$f":"1.63/1.12","v":1.4553571428571426},1.4,57,0.1171]
[15,"Italy",1.5,36.299999999999997,51,8.9200000000000002E-2]
[16,"Latvia",{"$f":"1.75/1.12","v":1.5624999999999998},0.7,61,8.1100000000000005E-2]
[17,"Lithuania",1.91,1.8,53,7.0099999999999996E-2]
[18,"Luxembourg",6,2.8,56,7.46E-2]
[19,"Malta",3.32,48.2,40,0.13469999999999999]
[20,"Netherlands",3.91,10.3,57,6.1100000000000002E-2]
[21,"Poland",2.15,18.399999999999999,37,6.7100000000000007E-2]
[22,"Portugal",1.82,15.1,51,7.8100000000000003E-2]
[23,"Romania",1.42,17.8,45,7.0999999999999994E-2]
[24,"Slovakia",2.4,0.7,48,7.9000000000000001E-2]
[25,"Slovenia",2.17,2.8,49,6.8900000000000003E-2]
[26,"Spain",1.78,29.6,57,0.1008]
[27,"Sweden",4.4400000000000004,1.4,64,6.7900000000000002E-2]
[28,"United Kingdom*",3.54,4.2,39,9.7000000000000003E-2]
[]
[null,"Average",{"$f":"AVERAGE(C2:C29)","v":3.1462882653061226},{"$f":"AVERAGE(D2:D29)","v":14.12962962962963},{"$f":"AVERAGE(E2:E29)","v":52},{"$f":"AVERAGE(F2:F29)","v":8.0775E-2}]
[null,"Minimum",{"$f":"MIN(C2:C29)","v":0.9375},{"$f":"MIN(D2:D29)","v":0.6},{"$f":"MIN(E2:E29)","v":37},{"$f":"MIN(F2:F29)","v":5.9299999999999999E-2}]
[null,"Maximum",{"$f":"MAX(C2:C29)","v":9},{"$f":"MAX(D2:D29)","v":72.3},{"$f":"MAX(E2:E29)","v":67},{"$f":"MAX(F2:F29)","v":0.13469999999999999}]
[]
[]
[null,"Primary treatment"]
[null,"Secondary treatment"]
[null,"Tertiary treatment"]
[null,"Advanced treatment"]
[]
[null,"Properly treated and disposed"]
[null,"Not properly treated or disposed"]
[]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[]
[null,"Lotic water body"]
[null,"Lentic water body "]
[null,"Marine water body"]

{"sheet":"MCA","index":3,"n_rows":7,"n_cols":8,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Criteria","Indicator","Baseline","Goal","Result","weightingfactors"]
["1. Capital and operative expenditures",{"$f":"+MCA_1!F18","v":1.1660927741752705},{"$f":"VLOOKUP(Input!B3,Database!B2:C29,2)","v":1.98},{"$f":"MIN(Database!C2:C29)","v":0.9375},{"$f":"IF(B2>C2,0,IF(B2<D2,100,FORECAST(B2,C7:D7,C2:D2)))","v":78.07263557071748},6,{"$f":"+F2/$F$7","v":0.3},{"$f":"+E2*G2","v":23.421790671215245}]
["2. Need for reuse",{"$f":"VLOOKUP(Input!B3,Database!B2:E29,3)","v":0.6},{"$f":"+Database!D32","v":0.6},{"$f":"+Database!D33","v":72.3},{"$f":"IF(B3=\"N/D\",0,FORECAST(B3,C7:D7,C3:D3))","v":1.8873791418627661E-15},1,{"$f":"+F3/$F$7","v":0.05},{"$f":"+E3*G3","v":9.4368957093138316E-17}]
["3. Social perception",{"$f":"VLOOKUP(Input!B3,Database!B2:E29,4)","v":48},{"$f":"+Database!E32","v":37},{"$f":"+Database!E33","v":67},{"$f":"IF(B4=\"N/D\",0,FORECAST(B4,C7:D7,C4:D4))","v":36.666666666666657},8,{"$f":"+F4/$F$7","v":0.4},{"$f":"+E4*G4","v":14.666666666666664}]
["4. Environmental impact",{"$f":"+MCA_4!B6","v":7.7789368360547551E-3},1E-8,12.6,{"$f":"IF(Input!B14=\"Lentic water body\",100,IF(Input!B14=\"Marine water body\",0,IF(AND(Input!B14=\"Lotic water body\",B5>D5),100,IF(B5<C5,0,FORECAST(B5,C7:D7,C5:D5)))))","v":6.1737514620846555E-2},4,{"$f":"+F5/$F$7","v":0.2},{"$f":"+E5*G5","v":1.2347502924169312E-2}]
["5. Occurrence frequency",{"$f":"HLOOKUP(Input!B3,MCA_5!E2:AF84,83)","v":17.5},{"$f":"+MCA_5!C84","v":17.5},{"$f":"+MCA_5!D84","v":29.25},{"$f":"IF(B6=\"N/D\",0,FORECAST(B6,C7:D7,C6:D6))","v":0},1,{"$f":"+F6/$F$7","v":0.05},{"$f":"+E6*G6","v":0}]
[null,null,0,100,null,{"$f":"SUM(F2:F6)","v":20},null,{"$f":"ROUND(SUM(H2:H6),0)","v":38}]

{"sheet":"MCA_1","index":4,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
["Input Flow (m3/d)",{"$f":"+Input!B12","v":"8.700"}]
["Advanced treatment fraction (%)",{"$f":"+Input!B27","v":"100"}]
["Design Flow (m3/d)",{"$f":"+B2*(B3/100)","v":8700}]
["RO Conversion factor",0.7]
["Flow* (m3/d)",{"$f":"+B4*B5","v":6090}]
["Design to average factor",0.5]
["Interest rate (%)",{"$f":"+Input!B35/100","v":0.02}]
["Life span (years)",{"$f":"+Input!B37","v":20}]
["Energy price (€/KWh)",{"$f":"VLOOKUP(Input!B3,Database!B2:F29,5)","v":8.48E-2}]
["Process","Boolean factor","CAPEX (€)","CAPEX_Anuity (€/year)","OPEX (€/year)","Anuity (€/m3)",null,"Energy Consumption (kWh/m3)","Energy Consumption (kWh)","Annual Energy Price (€/year)"]
["Sand Filtration",{"$f":"+Input!B20","v":1},{"$f":"10^(0.1886*LOG10(B4)^2-0.9659*LOG10(B4)+6.3895)*B12","v":324604.76155815111},{"$f":"-PMT($B$8,$B$9,C12)*B12","v":19851.761904738945},{"$f":"10^(0.2525*LOG10(B4)^2 -1.5751*LOG10(B4) + 6.4671)*B12","v":15160.577347884071},{"$f":"+(D12+E12)/($B$4*$B$7)/365","v":2.2051544167925059E-2},null,{"$f":"0.04*B12","v":0.04},{"$f":"+H12*$B$4*$B$7/24","v":7.25},{"$f":"+I12*24*365*$B$10","v":5385.6480000000001}]
["Membrane Filtration",{"$f":"+Input!B21","v":1},{"$f":"10^(0.09188*LOG10($B$4)^2+0.01813*LOG10($B$4)+5.0066)*B13","v":3191418.8456039117},195176.70276033808,{"$f":"10^(0.0698*LOG10($B$4)^2+0.1977*LOG10($B$4)+3.4035)*B13","v":184342.65145159001},{"$f":"+(D13+E13)/($B$4*$B$7)/365","v":0.23902966727251021},null,{"$f":"0.15*B13","v":0.15},{"$f":"+H13*$B$4*$B$7/24","v":27.1875},20196.18]
["Ultraviolet",{"$f":"+Input!B22","v":1},{"$f":"10^(0.055*LOG10($B$4)^2+0.2928*LOG10($B$4)+3.5368)*B14","v":349849.20710084925},21395.629345022982,{"$f":"10^(0.0146*LOG10($B$4)^2+0.3355*LOG10($B$4)+3.0037)*B14","v":35644.946203897569},{"$f":"+(D14+E14)/($B$4*$B$7)/365","v":3.5925413666459169E-2},null,{"$f":"0.035*B14","v":3.5000000000000003E-2},{"$f":"+H14*$B$4*$B$7/24","v":6.3437500000000009},4712.4420000000009]
["Reverse Osmosis",{"$f":"+Input!B23","v":1},{"$f":"10^(0.0957*LOG10($B$4)^2+0.0825*LOG10($B$4)+4.5138)*B15","v":2108901.7207054184},128973.50808712115,{"$f":"10^(0.0701*LOG10($B$4)^2+0.2704*LOG10($B$4)+3.3515)*B15","v":319657.44439409656},{"$f":"+(D15+E15)/($B$4*$B$7)/365","v":0.28255767751926797},null,{"$f":"1*B15","v":1},{"$f":"+H15*$B$4*$B$7/24","v":181.25},134641.20000000001]
["GAC filtration",{"$f":"+Input!B24","v":1},{"$f":"10^(0.0255*LOG10($B$6)^2+0.568*LOG10($B$6)+3.6987)*B16","v":1635337.8458437873},100011.8956778881,{"$f":"10^(0.0015*LOG10($B$6)^2+0.5343*LOG10($B$6)+3.4657)*B16","v":323076.97771000041},{"$f":"+(D16+E16)/($B$6*$B$7)/365","v":0.38067244608308121},null,{"$f":"0.04*B16","v":0.04},{"$f":"+H16*B6*$B$7/24","v":5.0750000000000002},3769.9536000000007]
["Ozone",{"$f":"+Input!B25","v":1},{"$f":"10^(0.0753*LOG10($B$6)^2-0.0052*LOG10($B$6)+5.1189)*B17","v":1505797.5714355742},92089.637630032244,{"$f":"10^(0.2543*LOG10($B$6)^2-1.5575*LOG10($B$6)+7.3879)*B17","v":136703.89547354655},{"$f":"+(D17+E17)/($B$6*$B$7)/365","v":0.20585602546602677},null,{"$f":"0.15*B17","v":0.15},{"$f":"+H17*B6*$B$7/24","v":19.03125},14137.326000000001]
[null,null,{"$f":"SUM(C12:C17)","v":9115909.9522476923},null,{"$f":"SUM(E12:E17)","v":1014586.4925810152},{"$f":"SUM(F12:F17)","v":1.1660927741752705},null,{"$f":"SUM(H12:H17)","v":1.415},{"$f":"SUM(I12:I17)","v":246.13749999999999},{"$f":"SUM(J12:J17)","v":182842.74960000004}]

{"sheet":"MCA_4","index":5,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
["C_local_effluent (ug/L)",12.6]
["Q_wwtp (m3/d)",{"$f":"+Input!B12","v":"8.700"}]
["Q_river (m3/s)",{"$f":"+Input!B16","v":"163"}]
["D",{"$f":"(B3+B4*3600*24)/B3","v":1619.7586206896551}]
["C_local_water (ug/L)",{"$f":"+B2/B5","v":7.7789368360547551E-3}]

{"sheet":"MCA_5","index":6,"n_rows":84,"n_cols":40,"rows_kept":84,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28]
["#","Substance","Classification","CAS #","Austria","Belgium","Bulgaria","Croatia","Cyprus","Czech Republic","Denmark","Estonia","Finland","France","Germany","Greece","Hungary","Ireland","Italy","Latvia","Lithuania","Luxembourg","Malta","Netherlands","Poland","Portugal","Romania","Slovakia","Slovenia","Spain","Sweden","UK*",null,null,"DERC","ENEC","DERC & ENEC"]
[1,50,"Priority substance","15972-60-8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(E3:AF3,$AI$2)","v":0},{"$f":"COUNTIF(F3:AH3,$AJ$2)","v":0},{"$f":"+AI3+AJ3","v":0}]
[2,"Anthracene","Priority substance","120-12-7",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(E4:AF4,$AI$2)","v":0},{"$f":"COUNTIF(F4:AH4,$AJ$2)","v":0},{"$f":"+AI4+AJ4","v":0}]
[3,"Atrazine","Priority substance","1912-24-9",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[4,"Benzene","Priority substance","71-43-2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[5,"Brominated diphenylethers","Priority substance","32534-81-9",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[6,"Cadmium and its compounds","Priority substance","7440-43-9",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["6a","Carbon-tetrachloride","Priority substance","56-23-5","ENEC","DERC","ENEC","ENEC","ENEC","ENEC","NA","NA","NA","DERC","DERC","NA","ENEC","NA","NA","NA","NA","NA","NA","DERC","NA","NA","ENEC","DERC","NA","NA","NA","NA",null,null,5,6,11,null,null,{"$f":"HLOOKUP(Input!$B$3,MCA_5!$E$2:$AF$76,8)","v":"ENEC"}]
[7,"C10-13, Chloroalkanes","Priority substance","85535-84-8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[8,"Chlorfenvinphos","Priority substance","470-90-6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[9,"Chlorpyrifos (Chlorpyrifos-ethyl)","Priority substance","2921-88-2","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA",null,null,0,0,0,null,null,{"$f":"HLOOKUP(Input!$B$3,MCA_5!$E$2:$AF$76,11)","v":"NA"}]
["9a","Cyclodine pesticides: Aldrin, Dieldrin, Endrin and Isodrin","Priority substance","309-00-2 / 60-57-1 / 72-20-8/465-73-6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["9b","DDT total","Priority substance","not applicable",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["9c","para-para-DDT","Priority substance","50-29-3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[10,"1, 2-Dichloroethane","Priority substance","107-06-2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[11,"Dichloromethane","Priority substance","75-09-2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[12,"Di(2-ethylhexyl)-phthalate (DEHP)","Priority substance","117-81-7",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[13,"Diuron","Priority substance","330-54-1","DERC","NA","DERC","DERC","NA","NA","NA","NA","NA","DERC","DERC","NA","DERC","NA","NA","NA","NA","NA","NA","DERC","NA","NA","DERC","DERC","NA","NA","DERC","NA",null,null,10,0,10,null,null,{"$f":"HLOOKUP(Input!$B$3,MCA_5!$E$2:$AF$76,18)","v":"DERC"}]
[14,"Endosulfan","Priority substance","115-29-7",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[15,"Fluoranthene","Priority substance","206-44-0",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[16,"Hexachlorobenzene","Priority substance","118-74-1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[17,"Hexachlorobutadiene","Priority substance","87-68-3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[18,"Hexachlorocyclohexane (Lindane)","Priority substance","608-73-1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[19,"Isoproturon","Priority substance","34123-59-6","DERC","NA","DERC","DERC","NA","NA","NA","NA","NA","DERC","DERC","NA","DERC","NA","NA","NA","NA","NA","NA","DERC","NA","NA","DERC","DERC","NA","NA","DERC","NA",null,null,10,0,10,null,null,{"$f":"HLOOKUP(Input!$B$3,MCA_5!$E$2:$AF$76,24)","v":"DERC"}]
[20,"Lead and its compounds","Priority substance","7439-92-1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[21,"Mercury and its compounds","Priority substance","7439-97-6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[22,"Naphthalene","Priority substance","91-20-3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[23,"Nickel and its compounds","Priority substance","7440-02-0",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[24,"Nonylphenols (4-Nonylphenol)","Priority substance","84852-15-3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[25,"Octylphenols ((4-(1,1’,3,3’-tetramethylbutyl)-phenol)","Priority substance","140-66-9",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[26,"Pentachlorobenzene (PeCB)","Priority substance","608-93-5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[27,"Pentachlorophenol (PCP)","Priority substance","87-86-5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[28,"PAH - Bezo(a)pyrene","Priority substance","50-32-8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["28a","PAH - Benzo(b)fluoranthene","Priority substance","205-99-2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["28b","PAH - Benzo(k)fluoranthene","Priority substance","207-08-9",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["28c","PAH - Benzo(g,h,i)-perylene","Priority substance","191-24-2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["28d","PAH - Indeno(1,2,3-cd)-pyrene","Priority substance","193-39-5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[29,"Simazine","Priority substance","122-34-9",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["29a","Tetrachloroethylene (PERC)","Priority substance","127-18-4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
["29b","Trichloroethylene (TCE)","Priority substance","79-01-6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[30,"Tributyltin compounds (Tributyltincation) (TBT)","Priority substance","36643-28-4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[31,"Trichlorobenzenes","Priority substance","12002-48-1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[32,"Trichloromethane (Chloroform)","Priority substance","67-66-3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[33,"Trifluralin","Priority substance","1582-09-8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[34,"Dicofol","Priority substance","115-32-2","NA","NA","NA","NA","NA","NA","NA","NA","NA","DERC","DERC","NA","NA","NA","NA","NA","NA","NA","NA","DERC","NA","ENEC","NA","NA","NA","NA","NA","NA",null,null,3,1,4,null,null,{"$f":"HLOOKUP(Input!$B$3,MCA_5!$E$2:$AF$76,45)","v":"NA"}]
[35,"Perfluorooctane sulfonic acid and its derivatives (PFOS)","Priority substance","1763-23-1","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA",null,null,0,0,0,null,null,{"$f":"HLOOKUP(Input!$B$3,MCA_5!$E$2:$AF$76,46)","v":"NA"}]
[36,"Quinoxyfen","Priority substance","124495-18-7","ENEC","NA","ENEC","ENEC","NA","NA","NA","NA","NA","DERC","DERC","NA","ENEC","NA","NA","NA","NA","NA","NA","DERC","NA","ENEC","ENEC","ENEC","NA","NA","ENEC","NA",null,null,3,7,10,null,null,{"$f":"HLOOKUP(Input!$B$3,MCA_5!$E$2:$AF$76,47)","v":"ENEC"}]
[37,"Dioxins and dioxin-like compounds","Priority substance",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[38,"Aclonifen","Priority substance","74070-46-5","ENEC","NA","ENEC","ENEC","NA","NA","NA","NA","NA","DERC","DERC","NA","ENEC","NA","NA","NA","NA","NA","NA","DERC","NA","NA","ENEC","ENEC","NA","NA","ENEC","NA",null,null,3,6,9,null,null,{"$f":"HLOOKUP(Input!$B$3,MCA_5!$E$2:$AF$76,49)","v":"ENEC"}]
[39,"Bifenox","Priority substance","42576-02-3","ENEC","NA","ENEC","ENEC","NA","NA","NA","NA","NA","DERC","DERC","NA","ENEC","NA","NA","NA","NA","NA","NA","DERC","NA","NA","ENEC","ENEC","NA","NA","ENEC","NA",null,null,3,6,9,null,null,{"$f":"HLOOKUP(Input!$B$3,MCA_5!$E$2:$AF$76,50)","v":"ENEC"}]
[40,"Cybutryne","Priority substance","28159-98-0","DERC","NA","ENEC","ENEC","NA","NA","NA","NA","NA","ENEC","DERC","NA","DERC","NA","NA","NA","NA","NA","NA","DERC","NA","NA","ENEC","DERC","NA","NA","DERC","NA",null,null,6,4,10,null,null,{"$f":"HLOOKUP(Input!$B$3,MCA_5!$E$2:$AF$76,51)","v":"ENEC"}]
[41,"Cypermethrin","Priority substance","52315-07-8","ENEC","NA","ENEC","ENEC","NA","NA","NA","NA","ENEC","DERC","DERC","NA","ENEC","NA","NA","NA","NA","NA","NA","DERC","NA","NA","ENEC","NA","NA","NA","DERC","DERC",null,null,5,5,10,null,null,{"$f":"HLOOKUP(Input!$B$3,MCA_5!$E$2:$AF$76,52)","v":"ENEC"}]
[42,"Dichlorvos","Priority substance","62-73-7","ENEC","DERC","ENEC","ENEC","NA","NA","ENEC","NA","ENEC","DERC","DERC","NA","ENEC","NA","NA","NA","NA","NA","NA","DERC","NA","NA","ENEC","ENEC","NA","NA","DERC","NA",null,null,5,7,12,null,null,{"$f":"HLOOKUP(Input!$B$3,MCA_5!$E$2:$AF$76,53)","v":"ENEC"}]
[43,"Hexabromocyclododecane (HBCDD)","Priority substance","3194-55-6","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","NA","DERC","NA",null,null,1,0,1,null,null,{"$f":"HLOOKUP(Input!$B$3,MCA_5!$E$2:$AF$76,54)","v":"NA"}]
[44,"Heptachlor and heptachlor epoxide","Priority substance","76-44-8 / 1024-57-3","NA","DERC","NA","NA","DERC","NA","NA","NA","NA","DERC","DERC","NA","NA","NA","NA","NA","NA","NA","NA","DERC","NA","ENEC","NA","DERC","NA","NA","NA","NA",null,null,6,1,7,null,null,{"$f":"HLOOKUP(Input!$B$3,MCA_5!$E$2:$AF$76,55)","v":"NA"}]
[45,"Terbutryn","Priority substance","886-50-0","DERC","DERC","DERC","DERC","NA","NA","NA","NA","DERC","DERC","DERC","NA","DERC","NA","NA","NA","NA","NA","NA","DERC","NA","NA","DERC","DERC","NA","DERC","DERC","NA",null,5,13,0,13,null,null,{"$f":"HLOOKUP(Input!$B$3,MCA_5!$E$2:$AF$76,56)","v":"DERC"}]
[46,"17-alpha-ethinylestradiol (EE2)","First watch list","57-63-6","NA","ENEC","NA","NA","NA","NA","NA","NA","NA","ENEC","DERC","NA","NA","NA","ENEC","NA","NA","NA","NA","DERC","NA","NA","NA","NA","ENEC","NA","DERC","ENEC",null,null,3,5,8,null,null,{"$f":"HLOOKUP(Input!$B$3,MCA_5!$E$2:$AF$76,57)","v":"NA"}]
[47,"17-beta-estradiol (E2)","First watch list","50-28-2","DERC","NA","ENEC","ENEC","NA","NA","NA","NA","NA","DERC","DERC","NA","ENEC","NA","NA","NA","NA","NA","NA","ENEC","NA","NA","ENEC","ENEC","DERC","NA","DERC","NA",null,null,5,6,11,null,null,{"$f":"HLOOKUP(Input!$B$3,MCA_5!$E$2:$AF$76,58)","v":"ENEC"}]
[48,"Diclofenac","First watch list","15307-86-5","DERC","DERC","DERC","DERC","NA","DERC","NA","NA","NA","DERC","DERC","DERC","DERC","NA","DERC","NA","NA","NA","NA","DERC","NA","DERC","DERC","DERC","DERC","DERC","DERC","NA",null,1,17,0,17,null,null,{"$f":"HLOOKUP(Input!$B$3,MCA_5!$E$2:$AF$76,59)","v":"DERC"}]
[49,"Estrone (E1)","Second watch list","53-16-7","ENEC","DERC","DERC","ENEC","NA","ENEC","NA","NA","NA","DERC","ENEC","NA","DERC","NA","DERC","NA","NA","NA","NA","DERC","NA","NA","DERC","DERC","DERC","NA","NA","DERC",null,null,10,3,13,null,null,{"$f":"HLOOKUP(Input!$B$3,MCA_5!$E$2:$AF$76,60)","v":"ENEC"}]
[50,"Macrolide antibiotics (erythromycin, clarithromycin, azithromycin)","Second watch list","114-07-8 / 81103-11-9 / 83905-01-5","DERC","NA","DERC","DERC","NA","NA","NA","NA","NA","DERC","DERC","NA","DERC","NA","NA","NA","NA","NA","NA","DERC","NA","NA","DERC","ENEC","NA","DERC","DERC","NA",null,null,10,1,11,null,null,{"$f":"HLOOKUP(Input!$B$3,MCA_5!$E$2:$AF$76,61)","v":"DERC"}]
[51,"Methiocarb","Second watch list","2032-65-7","ENEC","NA","NA","NA","NA","NA","NA","NA","NA","DERC","NA","NA","ENEC","NA","NA","NA","NA","NA","NA","DERC","NA","NA","ENEC","NA","NA","NA","ENEC","NA",null,null,2,3,5,null,null,{"$f":"HLOOKUP(Input!$B$3,MCA_5!$E$2:$AF$76,62)","v":"NA"}]
[52,"Neonicotinoids (imidacloprid, thiacloprid, thiamethoxam, clothianidin, acetamiprid)","Second watch list","138261-41-3 / 111988-49-9 / 153719-23-4 / 210880-92-5 / 135410-20-7","ENEC","NA","ENEC","ENEC","NA","NA","NA","NA","NA","DERC","DERC","NA","ENEC","NA","NA","NA","NA","NA","NA","DERC","NA","ENEC","ENEC","NA","NA","NA","DERC","NA",null,null,4,5,9,null,null,{"$f":"HLOOKUP(Input!$B$3,MCA_5!$E$2:$AF$76,63)","v":"ENEC"}]
[53,"Metaflumizone","Second watch list","139968-49-3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0]
[54,"Amoxicillin","Second watch list","26787-78-0","DERC","NA","ENEC","DERC","NA","NA","NA","NA","NA","ENEC","DERC","NA","DERC","NA","NA","NA","NA","NA","NA","ENEC","NA","NA","ENEC","DERC","NA","NA","NA","NA",null,null,5,4,9,null,null,{"$f":"HLOOKUP(Input!$B$3,MCA_5!$E$2:$AF$76,65)","v":"DERC"}]
[55,"Ciprofloxacin","Second watch list","85721-33-1","NA","NA","NA","NA","NA","NA","NA","NA","NA","DERC","DERC","NA","NA","NA","NA","NA","NA","NA","NA","DERC","NA","DERC","NA","NA","NA","DERC","DERC","NA",null,null,6,0,6,null,null,{"$f":"HLOOKUP(Input!$B$3,MCA_5!$E$2:$AF$76,66)","v":"NA"}]
[56,"Carbamazepine"," Not included in the other categories","298-46-4","DERC","DERC","DERC","DERC","NA","DERC","NA","NA","NA","DERC","DERC","NA","DERC","NA","DERC","NA","NA","NA","NA","DERC","NA","DERC","DERC","DERC","DERC","DERC","DERC","NA",null,2,{"$f":"COUNTIF(E68:AF68,$AI$2)","v":16},{"$f":"COUNTIF(F68:AH68,$AJ$2)","v":0},{"$f":"+AI68+AJ68","v":16},null,null,{"$f":"HLOOKUP(Input!$B$3,MCA_5!$E$2:$AF$76,67)","v":"DERC"}]
[57,"Ibuprofen"," Not included in the other categories","15687-27-1","DERC","DERC","DERC","DERC","NA","DERC","NA","NA","NA","DERC","DERC","ENEC","DERC","NA","DERC","NA","NA","NA","NA","DERC","NA","DERC","DERC","DERC","DERC","DERC","DERC","NA",null,3,16,1,17,null,null,{"$f":"HLOOKUP(Input!$B$3,MCA_5!$E$2:$AF$76,68)","v":"DERC"}]
[58,"Fluoxetine (Prozac)"," Not included in the other categories","54910-89-3","NA","NA","NA","NA","NA","NA","NA","NA","NA","DERC","DERC","NA","NA","NA","NA","NA","NA","NA","NA","DERC","NA","ENEC","NA","NA","NA","DERC","DERC","NA",null,null,5,1,6,null,null,{"$f":"HLOOKUP(Input!$B$3,MCA_5!$E$2:$AF$76,69)","v":"NA"}]
[59,"Chloramphenicol"," Not included in the other categories","56-75-7","ENEC","NA","ENEC","ENEC","NA","NA","NA","NA","NA","NA","ENEC","NA","ENEC","NA","NA","NA","NA","NA","NA","DERC","NA","NA","ENEC","NA","NA","DERC","ENEC","NA",null,null,2,6,8,null,null,{"$f":"HLOOKUP(Input!$B$3,MCA_5!$E$2:$AF$76,70)","v":"ENEC"}]
[60,"Sulfamethoxazole"," Not included in the other categories","723-46-6","DERC","DERC","DERC","DERC","NA","DERC","NA","NA","NA","DERC","DERC","NA","DERC","NA","DERC","NA","NA","NA","NA","DERC","NA","NA","DERC","DERC","NA","DERC","DERC","NA",null,4,14,0,14,null,null,{"$f":"HLOOKUP(Input!$B$3,MCA_5!$E$2:$AF$76,71)","v":"DERC"}]
[61,"Ketoprofen"," Not included in the other categories","22071-15-4","ENEC","NA","ENEC","ENEC","NA","ENEC","NA","NA","NA","DERC","ENEC","DERC","ENEC","NA","DERC","NA","NA","NA","NA","DERC","NA","DERC","DERC","ENEC","DERC","DERC","DERC","NA",null,null,9,6,15,null,null,{"$f":"HLOOKUP(Input!$B$3,MCA_5!$E$2:$AF$76,72)","v":"ENEC"}]
[62,"Glyphosate"," Not included in the other categories","1071-83-6","DERC","DERC","DERC","ENEC","NA","NA","DERC","NA","NA","DERC","DERC","NA","ENEC","NA","NA","NA","NA","NA","NA","DERC","NA","NA","ENEC","DERC","NA","NA","DERC","NA",null,null,9,3,12,null,null,{"$f":"HLOOKUP(Input!$B$3,MCA_5!$E$2:$AF$76,73)","v":"ENEC"}]
[63,"AMPA"," Not included in the other categories","1066-51-9","DERC","DERC","DERC","DERC","NA","NA","NA","NA","NA","DERC","DERC","NA","DERC","NA","NA","NA","NA","NA","NA","DERC","NA","NA","DERC","DERC","NA","NA","DERC","NA",null,null,11,0,11,null,null,{"$f":"HLOOKUP(Input!$B$3,MCA_5!$E$2:$AF$76,74)","v":"DERC"}]
[64,"Estriol (E3)"," Not included in the other categories","50-27-1","NA","ENEC","NA","NA","NA","NA","NA","NA","NA","ENEC","ENEC","NA","NA","NA","NA","NA","NA","NA","NA","ENEC","NA","NA","NA","ENEC","DERC","NA","NA","ENEC",null,null,1,6,7,null,null,{"$f":"HLOOKUP(Input!$B$3,MCA_5!$E$2:$AF$76,75)","v":"NA"}]
[]
[null,null,"Weight","Result"]
[null,null,1,"DERC",{"$f":"COUNTIF(E3:E76,$D$79)","v":13},{"$f":"COUNTIF(F3:F76,$D$79)","v":11},11,10,1,4,1,0,1,25,25,2,12,0,6,0,0,0,0,27,0,5,11,14,7,10,20,2]
[null,null,0,"ENEC",{"$f":"COUNTIF(E3:E76,$D$80)","v":11},{"$f":"COUNTIF(F3:F76,$D$80)","v":2},12,13,1,3,1,0,2,4,4,1,12,0,1,0,0,0,0,3,0,5,13,8,1,0,5,2]
[null,null,0.75,"NA",{"$f":"COUNTIF(E3:E76,$D$81)","v":9},{"$f":"COUNTIF(F3:F76,$D$81)","v":20},10,10,31,26,31,33,30,4,4,30,9,33,26,33,33,33,33,3,33,23,9,11,25,23,8,29]
[null,null,null,null,{"$f":"SUM(E79:E81)","v":33},{"$f":"SUM(F79:F81)","v":33},{"$f":"SUM(G79:G81)","v":33},33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33]
[null,null,"Min","Max"]
[null,null,{"$f":"MIN(E84:AF84)","v":17.5},{"$f":"MAX(E84:AF84)","v":29.25},{"$f":"+E79*$C$79+E80*$C$80+E81*$C$81","v":19.75},26,18.5,17.5,24.25,23.5,24.25,24.75,23.5,28,28,24.5,18.75,24.75,25.5,24.75,24.75,24.75,24.75,29.25,24.75,22.25,17.75,22.25,25.75,27.25,26,23.75]

{"sheet":"Sum report","index":7,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Name","Koprivnica"]
["Country","Croatia"]
["Screening","satisfied"]
["Total score",58]
["CAPEX (million €)",9115909.9522476923]
["OPEX (thousands €/year)",1014586.4925810152]
["UWPC (€/m3)",1.1660927741752705]
["Energy consumption (kWh)",246.13749999999999]
["Energy price (€/kWh)",8.48E-2]
["Energy OPEX (thousands €/year)",182842.74960000004]
["Water exploitation index (%)",0.6]
["Water pollution as the main environmental issue (%)",48]
["Environmental impact of the discharge",1619.7586206896551]